Problem Note 61018: sas_batch.sh generates "ERROR 23-7: Invalid value for the option."
 |  |  |  |  |
The SAS® Merchandise Intelligence sas_batch.sh script might generate the following error in the SAS log file when it attempts to assign the DI_DM2 or DI_T_DBC libraries:
ERROR 23-7: Invalid value for the <library option> option.
ERROR: Library assignment failed for <libref>
The sas_batch.sh script retrieves information from SAS® Metadata Server to build a LIBNAME statement to connect to Oracle. The data retrieved includes the machine name, user ID, schema name, encrypted password, and LIBNAME options. Truncation occurs if the string generated with the retrieved data is more than 200 characters.
The workaround for this issue is to modify the password to reduce the encrypted password length.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.3 TS1M2 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.3 TS1M2 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| SAS System | SAS Pack Optimization | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#61018| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-02-26 13:02:35 |
| Date Created: | 2017-09-06 08:51:15 |